/*
 * To change this template, choose Tools | Templates and open the template in
 * the editor.
 */
package multiface.awwadco.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Iterator;
import java.util.List;
import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Query;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import multiface.awwadco.jpa.News;
import multiface.awwadco.jpa.PersistenceManager;
import multiface.awwadco.jpa.Utente;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

/**
 *
 * @author federico
 */
@WebServlet(name = "DeleteUtenteServlet", urlPatterns = {"/DeleteUtenteServlet"})
public class DeleteUtenteServlet extends HttpServlet {

    /**
     * Processes requests for both HTTP
     * <code>GET</code> and
     * <code>POST</code> methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    private static Log log = LogFactory.getLog(DeleteUtenteServlet.class);

    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
            HttpSession s = request.getSession();
            Utente u = (Utente) s.getAttribute("admin");
            if (u != null) {
                EntityManagerFactory emf = PersistenceManager.getInstance().getEntityManagerFactory();
                EntityManager em = emf.createEntityManager();

                if (em.createNamedQuery("Utente.findAll", Utente.class).getResultList().size() > 1) {

                    Utente c = em.createNamedQuery("Utente.findByIdutente", Utente.class).setParameter("idutente", Integer.parseInt(request.getParameter("idutente"))).getSingleResult();
                    Utente cn = em.createNamedQuery("Utente.findByIdutente", Utente.class).setParameter("idutente", Integer.parseInt(request.getParameter("iduser_go_news"))).getSingleResult();

                    Query q = em.createNativeQuery("SELECT n.* FROM news n WHERE n.utente_idutente=?", News.class);
                    q.setParameter(1, c);
                    List<News> list = q.getResultList();
                    //System.out.println("Size lista news: " + list.size());
                    Iterator<News> it = list.iterator();

                    while (it.hasNext()) {
                        News t = it.next();
                        t.setUtenteIdutente(cn);
                        em.getTransaction().begin();
                        em.persist(t);
                        em.getTransaction().commit();
                    }
                    em.getTransaction().begin();
                    em.remove(c);
                    em.getTransaction().commit();
                } else {
                    out.print("Not Possible delete ALL User, at least one administrator must exist.");
                }
                em.close();
                //emf.close();
            }
        } catch (Exception ex) {
            log.error(ex);
        } finally {
            out.close();
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** 
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /** 
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /** 
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}
